if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PreservationNoticeHistoryUpdateSent]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[PreservationNoticeHistoryUpdateSent]
GO

CREATE  PROCEDURE dbo.[PreservationNoticeHistoryUpdateSent]
(
	@PreservationNoticeHistoryID int,
	@EventType varchar(50),
	@DateMessageSent datetime
)
AS
SET NOCOUNT ON

UPDATE 
	PreservationNoticeHistory
SET 
	EventType = @EventType,
	DateEmailMessageSent = @DateMessageSent
WHERE 
	PreservationNoticeHistoryID = @PreservationNoticeHistoryID
GO